Prizm Services support two basic pagination modes for rendering Excel documents:
- Non-paginated
- Paginated
In non-paginated mode, each Excel sheet, irrespective of its size, is rendered onto a single page. If the number of columns and/or rows is large, then this might result in very small and unreadable output. In paginated mode, each Excel sheet is divided into a number of pages, such that each page fits into a specific size.
To customize Excel pagination settings, edit the central configuration file. Modify the following parameters to adjust pagination settings:
| Example |
Copy Code
|
|---|---|
fileTypes.excel.pagination.enabled: true fileTypes.excel.pagination.dimensions.minWidth: 11.0in fileTypes.excel.pagination.dimensions.maxWidth: 22.0in fileTypes.excel.pagination.dimensions.minHeight: 8.5in fileTypes.excel.pagination.dimensions.maxHeight: 17.0in |
|
- fileTypes.excel.pagination.enabled – set to "false" to disable pagination, set to "true" to enable pagination.
- fileTypes.excel.pagination.minWidth, fileTypes.excel.pagination.maxWidth, fileTypes.excel.pagination.minHeight, fileTypes.excel.pagination.maxHeight – non-negative doubles. These parameters specify the minimum and maximum sizes, in inches, for pages dynamically generated in the paginated rendering mode. If the 'fileTypes.excel.pagination.enabled' parameter is set to "false", then these 4 parameters are ignored.
 |
The following configuration properties have been deprecated and will be removed in a future release. Alter these properties only if not using the central configuration file. |
To customize Excel pagination settings using legacy configuration, edit the Watchdog configuration file located in the following default directories:
- Windows: C:\Prizm\PCCIS\Watchdog\watchdog.config
- Linux: /usr/share/prizm/pccis/Watchdog/watchdog.config
Modify the following parameters to adjust pagination settings:
| Example |
Copy Code
|
|---|---|
"officeConversionService": { ... "excelPagination":true, "excelPageWidthMin":11.0, "excelPageWidthMax":22.0, "excelPageHeightMin":8.5, "excelPageHeightMax":17.0 ... }, |
|
- excelPagination – set to "false" to disable pagination, set to "true" to enable pagination.
- excelPageWidthMin, excelPageWidthMax, excelPageHeightMin, excelPageHeightMax – non-negative doubles. These parameters specify the minimum and maximum sizes, in inches, for pages dynamically generated in the paginated rendering mode. If the 'excelPagination' parameter is set to "false", then these 4 parameters are ignored.